package com.merck.service.export;




public class SqlStr {

    /**
     * Qutly KPI report FBU
     */
    public static String KPI_FBU_REP_FD_C_FD_S_FD_P = "select *\n" +
            ",ab_planed_calls_ratio_m1  as ab_planed_calls_ratio_m1_p\n" +
            ",ab_planed_calls_ratio_m2  as ab_planed_calls_ratio_m2_p\n" +
            ",ab_planed_calls_ratio_m3  as ab_planed_calls_ratio_m3_p\n" +
            ",laboratory_calls_ratio_m1  as laboratory_calls_ratio_m1_p\n" +
            ",laboratory_calls_ratio_m2  as laboratory_calls_ratio_m2_p\n" +
            ",laboratory_calls_ratio_m3  as laboratory_calls_ratio_m3_p\n" +
            ",nurse_department_meeting_hcps_ratio_m1  as nurse_department_meeting_hcps_ratio_m1_p\n" +
            ",nurse_department_meeting_hcps_ratio_m2  as nurse_department_meeting_hcps_ratio_m2_p\n" +
            ",nurse_department_meeting_hcps_ratio_m3  as nurse_department_meeting_hcps_ratio_m3_p\n" +
            ",ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p\n" +
            ",art_register_rate_q  as art_register_rate_q_p\n" +
            ",laboratory_calls_ratio_score_q laboratory_calls_ratio_score_q_p\n" +
            ",laboratory_calls_ratio_q  as laboratory_calls_ratio_q_p\n" +
            ",weshare_times_score_q  as weshare_times_score_q_p\n" +
            ",lab_art_register_rate_q lab_art_register_rate_q_p\n" +
            ",lab_ab_hco_ratio_q lab_ab_hco_ratio_q_p\n" +
            ",lab_others_hco_ratio_q lab_others_hco_ratio_q_p\n" +
            ",nurse_department_meeting_hcps_ratio_q  as nurse_department_meeting_hcps_ratio_q_p\n" +
            ",art_register_rate_score_q  as art_register_rate_score_q_p\n" +
            ",ivf_report_score_q  as ivf_report_score_q_p\n" +
            ",lab_art_register_rate_score_q lab_art_register_rate_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",lab_hcps_hcos_ratio_score_q lab_hcps_hcos_ratio_score_q_p\n" +
            ",target_hcp_binding_ratio_score_q target_hcp_binding_ratio_score_q_p\n" +
            ",weshare_target_hcps_score_q weshare_target_hcps_score_q_p\n" +
            ",last_month_target_hcps_score_q last_month_target_hcps_score_q_p\n" +
            ",lesson_fee_in_time_score_q lesson_fee_in_time_score_q_p\n" +
            ",lesson_fee_return_rate_score_q lesson_fee_return_rate_score_q_p\n" +
            ",'' meeting\n" +
            ",target_hcp_binding_ratio_q target_hcp_binding_ratio_q_p\n" +
            ",lesson_fee_return_rate_q lesson_fee_return_rate_q_p\n" +
            ",(cast(ab_planed_calls_ratio_score_q as float)+cast(laboratory_calls_ratio_score_q as float)\n" +
            "+cast(target_hcp_binding_ratio_score_q as float)+cast(weshare_target_hcps_score_q as float)\n" +
            "+cast(art_register_rate_score_q as float)+cast(last_month_target_hcps_score_q as float)\n" +
            "+cast(product_test_score_q as float) +cast(lab_art_register_rate_score_q as float)\n" +
            "+cast(lab_hcps_hcos_ratio_score_q as float) +cast(lesson_fee_in_time_score_q as float)\n" +
            "+cast(lesson_fee_return_rate_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and (kpi_role = 'FD_C' or kpi_role = 'FD_S' or kpi_role = 'FD_P')and position = 'REP'\n";
        public static String KPI_FBU_DSM_FD_BA = "select *\n" +
                ",product_test_score_q  as product_test_score_q_p\n" +
                ",product_retention_q  as product_retention_q_p\n" +
                ",president_diretor_pharmancy_calls_score_q  as president_diretor_pharmancy_calls_score_q_p\n" +
                ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
                ",product_retention_score_q  as product_retention_score_q_p\n" +
                ",cso_channel_management_score_q  as cso_channel_management_score_q_p\n" +
                ",device_dealer_management_score_q  as device_dealer_management_score_q_p\n" +
                ",daily_behavior_score_q  as daily_behavior_score_q_p\n" +
                ",(cast(president_diretor_pharmancy_calls_score_q as float)+cast(hospital_warning_score_q as float)\n" +
                "+cast(product_retention_score_q as float)+cast(cso_channel_management_score_q as float)\n" +
                "+cast(device_dealer_management_score_q as float)+cast(product_test_score_q as float)\n" +
                "+cast(daily_behavior_score_q as float)\n" +
                ") as total\n" +
                "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and kpi_role = 'FD_BA' and position = 'DSM'\n" +
                "\n";
       //tt
        public static String KPI_FBU_DSM_FD_S_FD_C_FD_P = "select *\n" +
               ",daily_behavior_score_q  as daily_behavior_score_q_p\n" +
               ",s_call_hcps_ratio_q  as s_call_hcps_ratio_q_p\n" +
               ",weshare_pass_reps_ratio_q  as weshare_pass_reps_ratio_q_p\n" +
               ",laboratory_calls_ratio_q  as laboratory_calls_ratio_q_p\n" +
               ",expense_management_q  as expense_management_q_p\n" +
               ",art_register_rate_q  as art_register_rate_q_p\n" +
               ",bmr_assess_q  as bmr_assess_q_p\n" +
               ",product_test_score_q  as product_test_score_q_p\n" +
               ",avg_kpi_score_q  as avg_kpi_finalscore_q_p\n" +
               ",lab_hcps_hcos_ratio_score_q lab_hcps_hcos_ratio_score_q_p\n" +
               ",coaching_times_score_q  as coaching_times_score_q_p\n" +
               ",s_call_hcps_ratio_score_q  as s_call_hcps_ratio_score_q_p\n" +
               ",laboratory_calls_ratio_score_q  as laboratory_calls_ratio_score_q_p\n" +
               ",expense_management_score_q  as expense_management_score_q_p\n" +
               ",art_register_rate_score_q  as art_register_rate_score_q_p\n" +
               ",bmr_assess_score_q  as bmr_assess_score_q_p,avg_kpi_value_q as avg_kpi_value_q_p\n" +
               ",daily_behavior_score_q  as daily_behavior_score_q_p\n" +
               ",lab_art_register_rate_q lab_art_register_rate_q_p\n" +
               ",lab_ab_hco_ratio_q lab_ab_hco_ratio_q_p\n" +
               ",lab_others_hco_ratio_q lab_others_hco_ratio_q_p\n" +
               ",weshare_pass_reps_ratio_score_q  as weshare_pass_reps_ratio_score_q_p\n" +
               ",lab_art_register_rate_score_q lab_art_register_rate_score_q_p\n" +
               ",rep_meeting_execution_rate_q rep_meeting_execution_rate_q_p\n" +
               ",lesson_fee_in_time_and_return_rate_q lesson_fee_in_time_and_return_rate_q_p\n" +
               ",phase_breakthrough_speaker_coverage_score_q phase_breakthrough_speaker_coverage_score_q_p\n" +
               ",rep_meeting_execution_rate_score_q rep_meeting_execution_rate_score_q_p\n" +
               ",lesson_fee_in_time_and_return_rate_score_q lesson_fee_in_time_and_return_rate_score_q_p\n" +
               ",(cast(avg_kpi_score_q as float)+cast(coaching_times_score_q as float)\n" +
               "+cast(s_call_hcps_ratio_score_q as float)+cast(laboratory_calls_ratio_score_q as float)\n" +
               "+cast(art_register_rate_score_q as float)\n" +
               "+cast(bmr_assess_score_q as float)+cast(phase_breakthrough_speaker_coverage_score_q as float)\n" +
               "+cast(product_test_score_q as float)\n" +
               "+cast(lab_art_register_rate_score_q as float)+cast(lab_hcps_hcos_ratio_score_q as float)\n" +
               "+cast(rep_meeting_execution_rate_score_q as float)+cast(lesson_fee_in_time_and_return_rate_score_q as float)\n" +
               ") as total\n" +
               "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and (kpi_role = 'FD_C' or kpi_role = 'FD_S' or kpi_role = 'FD_P')and position = 'DSM'\n";
        public static String KPI_FBU_FT_DM_FT = "select *\n" +
                ",key_account_maintain_score_q  as key_account_maintain_score_q_p\n" +
                ",activity_execution_score_q  as activity_execution_score_q_p\n" +
                ",combination_score_q  as combination_score_q_p\n" +
                ",procurement_plan_score_q  as procurement_plan_score_q_p\n" +
                ",product_test_score_q  as product_test_score_q_p\n" +
                ",nc_team_training_score_q nc_team_training_score_q_p\n" +
                ",(cast(key_account_maintain_score_q as float)+cast(activity_execution_score_q as float)\n" +
                "+cast(combination_score_q as float)+cast(procurement_plan_score_q as float)\n" +
                "+cast(nc_team_training_score_q as float)\n" +
                ") as total\n" +
                "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and kpi_role = 'FT' and position = 'DSM'";
        public static String KPI_FBU_RSD_NAD = "select *\n" +
                ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
                ",s_call_hcps_ratio_q  as s_call_hcps_ratio_q_p\n" +
                ",weshare_pass_reps_ratio_q  as weshare_pass_reps_ratio_q_p\n" +
                ",art_register_rate_q  as art_register_rate_q_p\n" +
                ",expense_management_q  as expense_management_q_p\n" +
                ",turnover_rate_q  as turnover_rate_q_p\n" +
                ",ems_assess_q  as ems_assess_q_p\n" +
                ",transaction_management_q  as transaction_management_q_p\n" +
                ",avg_kpi_score_q  as avg_kpi_score_q_ps\n" +
                ",market_share_change_score_q  as market_share_change_score_q_p\n" +
                ",art_register_rate_score_q  as art_register_rate_score_q_p\n" +
                ",expense_management_score_q  as expense_management_score_q_p\n" +
                ",s_call_hcps_ratio_score_q  as s_call_hcps_ratio_score_q_p\n" +
                ",weshare_pass_reps_ratio_score_q  as weshare_pass_reps_ratio_score_q_p\n" +
                ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
                ",ems_assess_score_q  as ems_assess_score_q_p,avg_kpi_value_q avg_kpi_value_q_p\n" +
                ",transaction_management_score_q  as transaction_management_score_q_p\n" +
                ",event_execution_score_q event_execution_score_q_p\n" +
                ",speaker_coverage_score_q speaker_coverage_score_q_p\n" +
                ",(cast(avg_kpi_score_q as float)+cast(market_share_change_score_q as float)\n" +
                "+cast(art_register_rate_score_q as float)+cast(expense_management_score_q as float)\n" +
                "+cast(event_execution_score_q as float)+cast(speaker_coverage_score_q as float)\n" +
                "+cast(turnover_rate_score_q as float)+cast(ems_assess_score_q as float)\n" +
                "+cast(transaction_management_score_q as float)\n" +
                ") as total\n" +
                "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU'  and position = 'RSM'";

    /**
     * Quarterly KPI Report GBU
     */
    public static String KPI_GBU_REP_CHD = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p,call_hcps_ratio_score_q  as call_hcps_ratio_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p,prefessional_calls_score_q  as prefessional_calls_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p,product_test_score_q   as product_test_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",(cast(call_hcps_ratio_score_q as float)+cast(prefessional_calls_score_q as float)\n" +
            "+cast(product_test_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and kpi_role = 'CHD' and position = 'REP'";
    public static String KPI_GBU_REP_DB_CV_MIX = "select *, ab_planed_calls_ratio_score_q as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q as training_completion_score_q_p\n" +
            ",product_test_score_q as product_test_score_q_p\n" +
            ",vbp_hap_score_q as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p,is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",planed_prefessional_calls_ratio_m1  as planed_prefessional_calls_ratio_m1_p\n" +
            ",planed_prefessional_calls_ratio_m2  as planed_prefessional_calls_ratio_m2_p\n" +
            ",planed_prefessional_calls_ratio_m3  as planed_prefessional_calls_ratio_m3_p,planed_prefessional_calls_ratio_score_q as planed_prefessional_calls_ratio_score_q_p" +
            ",(cast(daily_prefessional_calls_score_q as float)+cast(planed_prefessional_calls_ratio_score_q as float)\n" +
            "+cast(is_new_binding_hcps_score_q as float)+cast(is_binding_hcps_ratio_score_q as float)\n" +
            "+cast(training_completion_score_q as float)+cast(product_test_score_q as float)+cast(vbp_hap_score_q as float)\n" +
            "+cast(vbp_procurement_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and (kpi_role = 'DB_A' or kpi_role = 'MIX' or kpi_role = 'CV' or kpi_role = 'DB_ID') and position = 'REP'";
//todo 临时

    public static String KPI_GBU_REP_CHD_DB = "select *, ab_planed_calls_ratio_score_q as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q as training_completion_score_q_p\n" +
            ",product_test_score_q as product_test_score_q_p\n" +
            ",vbp_hap_score_q as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p,is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",planed_prefessional_calls_ratio_m1  as planed_prefessional_calls_ratio_m1_p\n" +
            ",planed_prefessional_calls_ratio_m2  as planed_prefessional_calls_ratio_m2_p\n" +
            ",planed_prefessional_calls_ratio_m3  as planed_prefessional_calls_ratio_m3_p,planed_prefessional_calls_ratio_score_q as planed_prefessional_calls_ratio_score_q_p" +
            ",(cast(daily_prefessional_calls_score_q as float)+cast(planed_prefessional_calls_ratio_score_q as float)\n" +
            "+cast(is_new_binding_hcps_score_q as float)+cast(is_binding_hcps_ratio_score_q as float)\n" +
            "+cast(training_completion_score_q as float)+cast(product_test_score_q as float)+cast(vbp_hap_score_q as float)\n" +
            "+cast(vbp_procurement_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and kpi_role = 'CHD' and position = 'REP'";




    public static String KPI_GBU_REP_TD_ST = "select *, ab_planed_calls_ratio_score_q as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q as training_completion_score_q_p\n" +
            ",product_test_score_q as product_test_score_q_p\n" +
            ",vbp_hap_score_q as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q as marketing_activities_score_q_p\n" +
            ",planed_prefessional_calls_ratio_m1  as planed_prefessional_calls_ratio_m1_p\n" +
            ",planed_prefessional_calls_ratio_m2  as planed_prefessional_calls_ratio_m2_p\n" +
            ",planed_prefessional_calls_ratio_m3  as planed_prefessional_calls_ratio_m3_p,planed_prefessional_calls_ratio_score_q as planed_prefessional_calls_ratio_score_q_p" +
            ",(cast(daily_prefessional_calls_score_q as float)+cast(planed_prefessional_calls_ratio_score_q as float)\n" +
            "+cast(is_new_binding_hcps_score_q as float)+cast(is_binding_hcps_ratio_score_q as float)\n" +
            "+cast(training_completion_score_q as float)+cast(product_test_score_q as float)\n" +
            "+cast(expand_customer_score_q as float)+cast(marketing_activities_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and (kpi_role = 'TD' or kpi_role = 'ST') and position = 'REP'";
    public static String KPI_GBU_DSM_HA = "select *, ab_planed_calls_ratio_score_q as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q as training_completion_score_q_p\n" +
            ",product_test_score_q as product_test_score_q_p\n" +
            ",vbp_hap_score_q as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q  as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q as actual_work_days_score_q_p\n" +
            ",president_calls_score_q as president_calls_score_q_p\n" +
            ",director_calls_score_q as director_calls_score_q_p\n" +
            ",hospital_warning_score_q as hospital_warning_score_q_p\n" +
            ",product_retention_score_q as product_retention_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p,(cast(actual_work_days_score_q as float)+cast(president_calls_score_q as float)\n" +
            "+cast(director_calls_score_q as float)+cast(hospital_warning_score_q as float)\n" +
            "+cast(product_retention_score_q as float)+cast(training_completion_score_q as float)\n" +
            "+cast(product_test_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and kpi_role = 'HA' and position = 'DSM'";
    //tt
    public static String KPI_GBU_DSM_ST_TD = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p,daily_prefessional_calls_avg_kpi_value_q as daily_prefessional_calls_avg_kpi_value_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p,planed_calls_ratio_avg_kpi_value_q as planed_calls_ratio_avg_kpi_value_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p,weshare_avg_kpi_value_q as weshare_avg_kpi_value_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p,daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",(cast(daily_prefessional_calls_avg_kpi_score_q as float)+cast(planed_calls_ratio_avg_kpi_score_q as float)\n" +
            "+cast(weshare_avg_kpi_score_q as float)+cast(coaching_coverage_score_q as float)\n" +
            "+cast(coaching_quality_score_q as float)+cast(marketing_activities_score_q as float)\n" +
            "+cast(training_completion_score_q as float)+cast(product_test_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and (kpi_role = 'TD' or kpi_role = 'ST') and position = 'DSM'";
    //tt
    public static String KPI_GBU_DSM_DB_CV_MIX_CHD = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p,prefessional_calls_avg_kpi_value_q as prefessional_calls_avg_kpi_value_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p,daily_prefessional_calls_avg_kpi_value_q as daily_prefessional_calls_avg_kpi_value_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p,call_hcps_ratio_avg_kpi_value_q as call_hcps_ratio_avg_kpi_value_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p,planed_calls_ratio_avg_kpi_value_q as planed_calls_ratio_avg_kpi_value_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p,weshare_avg_kpi_value_q as weshare_avg_kpi_value_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",coaching_quality_m1 as coaching_quality_m1_p\n" +
            ",coaching_quality_m2 as coaching_quality_m2_p\n" +
            ",coaching_quality_m3 as coaching_quality_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",call_hcps_ratio_avg_kpi_score_q  as call_hcps_ratio_avg_kpi_finalscore_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",call_hcps_ratio_avg_kpi_score_q  as call_hcps_ratio_avg_kpi_finalscore_q_ps\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            "\n" +
            ",(cast(coaching_coverage_score_q as float)+cast(coaching_quality_score_q as float)\n" +
            "+cast(vbp_hap_score_q as float)+cast(vbp_procurement_score_q as float)\n" +
            "+cast(training_completion_score_q as float)+cast(product_test_score_q as float)" +
            "+cast(prefessional_calls_avg_kpi_score_q as float) +cast(daily_prefessional_calls_avg_kpi_score_q as float)" +
            "+cast(call_hcps_ratio_avg_kpi_score_q as float)+cast(planed_calls_ratio_avg_kpi_score_q as float)" +
            "+cast(weshare_avg_kpi_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and (kpi_role = 'DB_A' or kpi_role = 'MIX' or kpi_role = 'CV'  or kpi_role = 'CHD') and position = 'DSM'";
    public static String KPI_GBU_RSM = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p,avg_kpi_value_q as avg_kpi_value_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p,avg_kpi_score_q as avg_kpi_score_q_ps\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",(cast(vbp_hap_score_q as float)+cast(vbp_procurement_score_q as float)\n" +
            "+cast(management_ability_score_q as float)+cast(turnover_rate_score_q as float)\n" +
            "+cast(avg_kpi_score_q as float) +cast(expense_management_score_q as float)\n" +
            "+cast(regional_promotion_score_q as float) +cast(talent_retaining_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU'  and position = 'RSM'";
    /**
     * Quarterly KPI Report KA
     */
    public static String KPI_KA_DSM_KA = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            "\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            "\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",attended_attendees_ratio_q  as attended_attendees_ratio_q_p\n" +
            ",event_times_score_q  as event_times_score_q_p\n" +
            ",attended_attendees_ratio_score_q  as attended_attendees_ratio_score_q_p\n" +
            ",(cast(president_calls_score_q as float)+cast(director_calls_score_q as float)\n" +
            "+cast(event_times_score_q as float)+cast(attended_attendees_ratio_score_q as float)\n" +
            "+cast(product_test_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='KA' and kpi_role = 'KA' and position = 'DSM'";
    /**
     * Quarterly KPI Report OBU
     */

    public static String KPI_OBU_REP_Erbitux = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",attended_attendees_ratio_q  as attended_attendees_ratio_q_p\n" +
            ",event_times_score_q  as event_times_score_q_p\n" +
            ",attended_attendees_ratio_score_q  as attended_attendees_ratio_score_q_p\n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            ",ab_call_hcps_ratio_m1  as ab_call_hcps_ratio_m1_p\n" +
            ",ab_call_hcps_ratio_m2  as ab_call_hcps_ratio_m2_p\n" +
            ",ab_call_hcps_ratio_m3  as ab_call_hcps_ratio_m3_p\n" +
            ",actual_work_days_ratio_score_q  as actual_work_days_ratio_score_q_p\n" +
            ",ab_call_hcps_ratio_score_q  as ab_call_hcps_ratio_score_q_p\n" +
            ",call_hcps_ratio_score_q  as call_hcps_ratio_score_q_p\n" +
            ",daily_actual_calls_score_q  as daily_actual_calls_score_q_p\n" +
            ",department_meeting_quality_score_q  as department_meeting_quality_score_q_p\n" +
            ",(cast(actual_work_days_ratio_score_q as float)+cast(ab_call_hcps_ratio_score_q as float)\n" +
            "+cast(call_hcps_ratio_score_q as float)+cast(daily_actual_calls_score_q as float)\n" +
            "+cast(is_new_binding_hcps_score_q as float)+cast(is_binding_hcps_ratio_score_q as float)\n" +
            "+cast(product_test_score_q as float)+cast(department_meeting_quality_score_q as float)\n" +
            "+cast(expense_management_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU' and upper(kpi_role) = 'ERBITUX' and position = 'REP'\n" +
            "\n";

    public static String KPI_OBU_REP_Xalkori = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",attended_attendees_ratio_q  as attended_attendees_ratio_q_p\n" +
            ",event_times_score_q  as event_times_score_q_p\n" +
            ",attended_attendees_ratio_score_q  as attended_attendees_ratio_score_q_p\n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            ",ab_call_hcps_ratio_m1  as ab_call_hcps_ratio_m1_p\n" +
            ",ab_call_hcps_ratio_m2  as ab_call_hcps_ratio_m2_p\n" +
            ",ab_call_hcps_ratio_m3  as ab_call_hcps_ratio_m3_p\n" +
            ",actual_work_days_ratio_score_q  as actual_work_days_ratio_score_q_p\n" +
            ",ab_call_hcps_ratio_score_q  as ab_call_hcps_ratio_score_q_p\n" +
            ",call_hcps_ratio_score_q  as call_hcps_ratio_score_q_p\n" +
            ",daily_actual_calls_q  as daily_actual_calls_q_p\n" +
            ",department_meeting_quality_score_q  as department_meeting_quality_score_q_p\n" +
            ",ab_call_hcps_ratio_q  as ab_call_hcps_ratio_q_p\n" +
            ",joint_promotion_rate_score_q  as joint_promotion_rate_score_q_p\n" +
            ",sample_testing_rate_score_q  as sample_testing_rate_score_q_p\n" +
            ",monthly_actual_calls_score_q  as monthly_actual_calls_score_q_p\n" +
            ",(cast(joint_promotion_rate_score_q as float)+cast(sample_testing_rate_score_q as float)\n" +
            "+cast(product_test_score_q as float)+cast(ab_call_hcps_ratio_score_q as float)\n" +
            "+cast(monthly_actual_calls_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU' and upper(kpi_role) = 'ERBITUX XALKORI' and position = 'REP'";
    //tt
    public static String KPI_OBU_DSM = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",coaching_quality_m1 as coaching_quality_m1_p\n" +
            ",coaching_quality_m2 as coaching_quality_m2_p\n" +
            ",coaching_quality_m3 as coaching_quality_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            ",avg_kpi_value_q  as avg_kpi_value_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",attended_attendees_ratio_q  as attended_attendees_ratio_q_p\n" +
            ",event_times_score_q  as event_times_score_q_p\n" +
            ",attended_attendees_ratio_score_q  as attended_attendees_ratio_score_q_p\n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            ",ab_call_hcps_ratio_m1  as ab_call_hcps_ratio_m1_p\n" +
            ",ab_call_hcps_ratio_m2  as ab_call_hcps_ratio_m2_p\n" +
            ",ab_call_hcps_ratio_m3  as ab_call_hcps_ratio_m3_p\n" +
            ",actual_work_days_ratio_score_q  as actual_work_days_ratio_score_q_p\n" +
            ",ab_call_hcps_ratio_score_q  as ab_call_hcps_ratio_score_q_p\n" +
            ",call_hcps_ratio_score_q  as call_hcps_ratio_score_q_p\n" +
            ",daily_actual_calls_q  as daily_actual_calls_q_p\n" +
            ",department_meeting_quality_score_q  as department_meeting_quality_score_q_p\n" +
            ",ab_call_hcps_ratio_q  as ab_call_hcps_ratio_q_p\n" +
            ",joint_promotion_rate_score_q  as joint_promotion_rate_score_q_p\n" +
            ",sample_testing_rate_score_q  as sample_testing_rate_score_q_p\n" +
            ",monthly_actual_calls_score_q  as monthly_actual_calls_score_q_p\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_ps\n" +
            ",coaching_times_score_q  as coaching_times_score_q_p\n" +
            ",core_hospital_rate_score_q  as core_hospital_rate_score_q_p\n" +
            ",ems_rate_score_q  as ems_rate_score_q_p\n" +
            ",(cast(avg_kpi_score_q as float)+cast(actual_work_days_ratio_score_q as float)\n" +
            "+cast(coaching_quality_score_q as float)+cast(coaching_times_score_q as float)\n" +
            "+cast(core_hospital_rate_score_q as float)+cast(ems_rate_score_q as float)\n" +
            "+cast(product_test_score_q as float)+cast(expense_management_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU' and position = 'DSM'";

    public static String KPI_OBU_RSM = "select *, ab_planed_calls_ratio_score_q  as ab_planed_calls_ratio_score_q_p \n" +
            ",daily_prefessional_calls_score_q  as daily_prefessional_calls_score_q_p\n" +
            ",is_new_binding_hcps_score_q  as is_new_binding_hcps_score_q_p\n" +
            ",is_binding_hcps_ratio_score_q  as is_binding_hcps_ratio_score_q_p\n" +
            ",training_completion_score_q  as training_completion_score_q_p\n" +
            ",product_test_score_q  as product_test_score_q_p\n" +
            ",vbp_hap_score_q  as vbp_hap_score_q_p,avg_kpi_value_q as avg_kpi_value_q_p\n" +
            ",vbp_procurement_score_q as vbp_procurement_score_q_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            ",expand_customer_score_q  as expand_customer_score_q_p\n" +
            ",marketing_activities_score_q  as marketing_activities_score_q_p\n" +
            ",actual_work_days_score_q  as actual_work_days_score_q_p\n" +
            ",president_calls_score_q  as president_calls_score_q_p\n" +
            ",director_calls_score_q  as director_calls_score_q_p\n" +
            ",hospital_warning_score_q  as hospital_warning_score_q_p\n" +
            ",product_retention_score_q  as product_retention_score_q_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_p\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_p\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_p\n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            ",daily_prefessional_calls_avg_kpi_score_q  as daily_prefessional_calls_avg_kpi_score_q_ps\n" +
            ",planed_calls_ratio_avg_kpi_score_q  as planed_calls_ratio_avg_kpi_score_q_ps\n" +
            ",weshare_avg_kpi_score_q  as weshare_avg_kpi_score_q_ps\n" +
            ",coaching_coverage_score_q  as coaching_coverage_score_q_p\n" +
            ",coaching_quality_score_q  as coaching_quality_score_q_p\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_p\n" +
            "\n" +
            ",prefessional_calls_avg_kpi_score_q  as prefessional_calls_avg_kpi_score_q_ps\n" +
            "\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_p\n" +
            ",expense_management_score_q  as expense_management_score_q_p\n" +
            ",regional_promotion_score_q  as regional_promotion_score_q_p\n" +
            ",turnover_rate_score_q  as turnover_rate_score_q_p\n" +
            ",talent_retaining_score_q  as talent_retaining_score_q_p\n" +
            ",management_ability_score_q  as management_ability_score_q_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",attended_attendees_ratio_q  as attended_attendees_ratio_q_p\n" +
            ",event_times_score_q  as event_times_score_q_p\n" +
            ",attended_attendees_ratio_score_q  as attended_attendees_ratio_score_q_p\n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            ",ab_call_hcps_ratio_m1  as ab_call_hcps_ratio_m1_p\n" +
            ",ab_call_hcps_ratio_m2  as ab_call_hcps_ratio_m2_p\n" +
            ",ab_call_hcps_ratio_m3  as ab_call_hcps_ratio_m3_p\n" +
            ",actual_work_days_ratio_score_q  as actual_work_days_ratio_score_q_p\n" +
            ",ab_call_hcps_ratio_score_q  as ab_call_hcps_ratio_score_q_p\n" +
            ",call_hcps_ratio_score_q  as call_hcps_ratio_score_q_p\n" +
            ",daily_actual_calls_q  as daily_actual_calls_q_p\n" +
            ",department_meeting_quality_score_q  as department_meeting_quality_score_q_p\n" +
            ",ab_call_hcps_ratio_q  as ab_call_hcps_ratio_q_p\n" +
            ",joint_promotion_rate_score_q  as joint_promotion_rate_score_q_p\n" +
            ",sample_testing_rate_score_q  as sample_testing_rate_score_q_p\n" +
            ",monthly_actual_calls_score_q  as monthly_actual_calls_score_q_p\n" +
            ",avg_kpi_score_q  as avg_kpi_score_q_ps\n" +
            ",coaching_times_score_q  as coaching_times_score_q_p\n" +
            ",core_hospital_rate_score_q  as core_hospital_rate_score_q_p\n" +
            ",ems_rate_score_q  as ems_rate_score_q_p\n" +
            ",forecast_accuracy_score_q  as forecast_accuracy_score_q_p\n" +
            ",management_assessment_score_q  as management_assessment_score_q_p\n" +
            ",(cast(avg_kpi_score_q as float)+cast(turnover_rate_score_q as float)\n" +
            "+cast(expense_management_score_q as float)+cast(forecast_accuracy_score_q as float)\n" +
            "+cast(management_assessment_score_q as float)\n" +
            ") as total\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU'  and position = 'RSM'\n" +
            "\n";



    /**
     * Monthly KPI Report FBU
     */
    public static String KPI_FBU_REP_FD_C_FD_S_FD_P_M = "select *\n" +
            ",ab_planed_calls_ratio_m1  as ab_planed_calls_ratio_m1_p\n" +
            ",ab_planed_calls_ratio_m2  as ab_planed_calls_ratio_m2_p\n" +
            ",ab_planed_calls_ratio_m3  as ab_planed_calls_ratio_m3_p\n" +
            ",laboratory_calls_ratio_m1  as laboratory_calls_ratio_m1_p\n" +
            ",laboratory_calls_ratio_m2  as laboratory_calls_ratio_m2_p,lab_others_hco_ratio_q lab_others_hco_ratio_q_p\n" +
            ",laboratory_calls_ratio_m3  as laboratory_calls_ratio_m3_p,lab_ab_hco_ratio_q lab_ab_hco_ratio_q_p\n" +
            ",nurse_department_meeting_hcps_ratio_m1  as nurse_department_meeting_hcps_ratio_m1_p\n" +
            ",nurse_department_meeting_hcps_ratio_m2  as nurse_department_meeting_hcps_ratio_m2_p\n" +
            ",nurse_department_meeting_hcps_ratio_m3  as nurse_department_meeting_hcps_ratio_m3_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and (kpi_role = 'FD_C' or kpi_role = 'FD_S' or kpi_role = 'FD_P') and position = 'REP'";

    public static String KPI_FBU_DSM_FD_BA_M = "select * from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and kpi_role = 'FD_BA' and position = 'DSM'";

    public static String KPI_FBU_DSM_FD_S_FD_C_FD_P_M = "select * \n" +
            ",s_call_hcps_ratio_q  as s_call_hcps_ratio_q_p,lab_others_hco_ratio_q lab_others_hco_ratio_q_p\n" +
            ",weshare_pass_reps_ratio_q  as weshare_pass_reps_ratio_q_p,lab_ab_hco_ratio_q lab_ab_hco_ratio_q_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU' and (kpi_role = 'FD_S' or kpi_role = 'FD_C' or kpi_role = 'FD_P') and position = 'DSM'";

    public static String KPI_FBU_RSD_NAD_M = "select * \n" +
            ",s_call_hcps_ratio_q  as s_call_hcps_ratio_q_p\n" +
            ",weshare_pass_reps_ratio_q  as weshare_pass_reps_ratio_q_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='FBU'  and position = 'RSM'";

    /**
     * Monthly KPI Report GBU
     */
    public static String KPI_GBU_DSM_ST_TD_DB_CV_MIX_CHD = "select * \n" +
            ",coaching_coverage_m1  as coaching_coverage_m1_p\n" +
            ",coaching_coverage_m2  as coaching_coverage_m2_p\n" +
            ",coaching_coverage_m3  as coaching_coverage_m3_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='GBU' and (kpi_role = 'TD' or kpi_role = 'ST' or kpi_role = 'DB_A' or kpi_role = 'MIX'or kpi_role = 'CV' \n" +
            "  or kpi_role = 'CHD') and position = 'DSM'";

    public static String KPI_GBU_REP_CHD_M = "select *,call_hcps_ratio_m1 call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2 call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3 call_hcps_ratio_m3_p\n" +
            "from lego_kpi_calculation.ads_kpi_final_report_qf\n" +
            "where bu = 'GBU' and kpi_role = 'CHD' and position = 'REP'";

    public static String KPI_GBU_REP_DB_CV_MIX_TD_ST = "select *,call_hcps_ratio_m1 call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2 call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3 call_hcps_ratio_m3_p\n" +
            ",is_binding_hcps_ratio_q is_binding_hcps_ratio_q_p" +
            ",planed_prefessional_calls_ratio_m1 planed_prefessional_calls_ratio_m1_p\n" +
            ",planed_prefessional_calls_ratio_m2 planed_prefessional_calls_ratio_m2_p\n" +
            ",planed_prefessional_calls_ratio_m3 planed_prefessional_calls_ratio_m3_p\n" +
            "from lego_kpi_calculation.ads_kpi_final_report_qf\n" +
            "where bu = 'GBU' and (kpi_role = 'TD' or kpi_role = 'ST' or kpi_role = 'MIX' or kpi_role = 'CV' or kpi_role = 'DB' or kpi_role = 'DB_A' or kpi_role = 'DB_ID') and position = 'REP'";

    public static String KPI_GBU_DSM_HA_M = "select *,call_hcps_ratio_m1 call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2 call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3 call_hcps_ratio_m3_p\n" +
            ",is_binding_hcps_ratio_q is_binding_hcps_ratio_q_p\n" +
            "from lego_kpi_calculation.ads_kpi_final_report_qf\n" +
            "where bu = 'GBU' and kpi_role = 'HA' and position = 'DSM'";

    /**
     * Monthly KPI Report OBU
     */
    public static String KPI_OBU_REP_Erbitux_M = "select * \n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            ",ab_call_hcps_ratio_m1  as ab_call_hcps_ratio_m1_p\n" +
            ",ab_call_hcps_ratio_m2  as ab_call_hcps_ratio_m2_p\n" +
            ",ab_call_hcps_ratio_m3  as ab_call_hcps_ratio_m3_p\n" +
            ",call_hcps_ratio_m1  as call_hcps_ratio_m1_p\n" +
            ",call_hcps_ratio_m2  as call_hcps_ratio_m2_p\n" +
            ",call_hcps_ratio_m3  as call_hcps_ratio_m3_p\n" +
            ",daily_prefessional_calls_m1  as daily_prefessional_calls_m1_p\n" +
            ",daily_prefessional_calls_m2  as daily_prefessional_calls_m2_p\n" +
            ",daily_prefessional_calls_m3  as daily_prefessional_calls_m3_p\n" +
            ",is_binding_hcps_ratio_q as is_binding_hcps_ratio_q_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU' and upper(kpi_role) = 'ERBITUX' and position = 'REP'";

    public static String KPI_OBU_REP_Xalkori_M = "select * from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU' and upper(kpi_role) = 'ERBITUX XALKORI' and position = 'REP'";

    public static String KPI_OBU_DSM_M = "select * \n" +
            ",actual_work_days_ratio_m1  as actual_work_days_ratio_m1_p\n" +
            ",actual_work_days_ratio_m2  as actual_work_days_ratio_m2_p\n" +
            ",actual_work_days_ratio_m3  as actual_work_days_ratio_m3_p\n" +
            "from  lego_kpi_calculation.ads_kpi_final_report_qf where bu='OBU'  and position = 'DSM'";

    /**
     * 导出成功邮件
     */
    public static String SUCESS_SEND_CONTENT = "<html lang=\"en\">\n" +
            "<head>\n" +
            "    <meta charset=\"UTF-8\">\n" +
            "    <title>Lego邮件提醒</title>\n" +
            "    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"/>\n" +
            "</head>\n" +
            "\n" +
            "<body style=\"margin: 0; padding: 0;\">\n" +
            "\n" +
            "<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\" style=\"border-collapse: collapse;\">\n" +
            "\n" +
            "    　\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"margin-left: 20px;margin-bottom: 1px;text-align: left;margin-top: 0px\">\n" +
            "                <p style=\"font-size: 25px;color: #0072bc;font-weight: bold;font-family: 'Merck';\">Merck Lego Platform</p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"border: #36649d 1px dashed;margin: 15px;padding: 30px\">\n" +
            "                <p style=\"font-size: 18px;color: #0072bc;font-weight: bold;font-family: 'Verdana','sans-serif';\">数据负责人，您好!</p>\n" +
            "                <p style=\"font-size: 14px;font-family: 'Verdana','sans-serif';line-height:25px;\">本次数据操作成功，请及时查看。</p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "    　\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"margin: 10px\">\n" +
            "                <p style=\"color: #343d47; font-size: 13px; margin: 0px 15px 9px; text-align: left;\" align=\"center\"><span style=\"color: black; font-size: 9pt;font-family: 'Verdana','sans-serif';\">本邮件由系统自动发送，请勿回复本邮件。</span></p>\n" +
            "                <p style=\"color: #343d47; font-size: 13px; margin: 0px 15px 9px; text-align: left;\" align=\"center\"><span style=\"color: black; font-size: 9pt;font-family: 'Verdana','sans-serif';\">如果您有任何疑问，请发送邮件至 <a href=mailto:LegoPlatformServiceMailbox@merckgroup.com>Lego Support</a></span></p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div align=\"right\" style=\"margin: 10px;border-top: solid 1px gray\" id=\"bottomTime\">\n" +
            "                <p style=\"margin-right: 14px;font-family: 'Verdana','sans-serif';font-size: 15px;\">Lego大数据平台</p>\n" +
            "                \n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "</table>\n" +
            "</body>\n" +
            "</html>";
    /**
     * 导出失败邮件
     */
    public static String FAILURE_SEND_CONTENT = "<html lang=\"en\">\n" +
            "<head>\n" +
            "    <meta charset=\"UTF-8\">\n" +
            "    <title>Lego邮件提醒</title>\n" +
            "    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"/>\n" +
            "</head>\n" +
            "<body style=\"margin: 0; padding: 0;\">\n" +
            "<table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\" style=\"border-collapse: collapse;\">\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"margin-left: 20px;margin-bottom: 1px;text-align: left;margin-top: 0px\">\n" +
            "                <p style=\"font-size: 25px;color: #0072bc;font-weight: bold;font-family: 'Merck';\">Merck Lego Platform</p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"border: #36649d 1px dashed;margin: 15px;padding: 30px\">\n" +
            "                <p style=\"font-size: 18px;color: #0072bc;font-weight: bold;font-family: 'Verdana','sans-serif';\">数据负责人，您好!</p>\n" +
            "                <p style=\"font-size: 14px;font-family: 'Verdana','sans-serif';line-height:25px;\">本次数据操作失败，程序运行异常，请联系管理员。详情请查看日志</p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div style=\"margin: 10px\">\n" +
            "                <p style=\"color: #343d47; font-size: 13px; margin: 0px 15px 9px; text-align: left;\" align=\"center\"><span style=\"color: black; font-size: 9pt;font-family: 'Verdana','sans-serif';\">本邮件由系统自动发送，请勿回复本邮件。</span></p>\n" +
            "                <p style=\"color: #343d47; font-size: 13px; margin: 0px 15px 9px; text-align: left;\" align=\"center\"><span style=\"color: black; font-size: 9pt;font-family: 'Verdana','sans-serif';\">如果您有任何疑问，请发送邮件至 <a href=mailto:LegoPlatformServiceMailbox@merckgroup.com>Lego Support</a></span></p>\n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "    <tr>\n" +
            "        <td>\n" +
            "            <div align=\"right\" style=\"margin: 10px;border-top: solid 1px gray\" id=\"bottomTime\">\n" +
            "                <p style=\"margin-right: 14px;font-family: 'Verdana','sans-serif';font-size: 15px;\">Lego大数据平台</p> \n" +
            "            </div>\n" +
            "        </td>\n" +
            "    </tr>\n" +
            "</table>\n" +
            "</body>\n" +
            "</html>";


    public static void main(String[] args) {
        System.out.println(KPI_FBU_DSM_FD_S_FD_C_FD_P);
    }



}

